how to manage sql server

After so many years of mixing in the forum, we have seen an obvious trend: more and more netizens are using VFP and SQL server for the system. Many people are concerned about how to operate or manage SQL Server from VFP. You can use views, SPT, or

How to solve the connection problem in SQL Server 2000 Applicable Important: This article contains information about modifying the registry. Before modifying the registry, you must back up the registry and know how to restore the Registry in case of

server| Resolution | How the problem resolves connection problems in SQL Server 2000 apply to important notes: This article contains information about modifying the registry. Be sure to back up the registry before you modify the registry, and be

Manage SQL Server on Windows Azure with SQL Manage SutudioWhen it comes to SQL creation on Windows Azure, which we've covered in our previous article, what we're going to cover today, we found that there is no SQL Server Agent option feature under

30. Microsoft SQL Server ManagementAutomatic Setting of SQL ServerDatabase Maintenance PlanSummaryUsing appropriate settings and performing routine maintenance tasks in the database is the key to optimizing the server. This chapter describes the

35. use SQL query analyzer and SQL profilerUse SQL query AnalyzerUse SQL profilerOptimize T-SQL statementSummaryIn this chapter, we will continue with the description of the pre-stored procedures in Chapter 21st. This chapter describes how to use

Using PowerShell to manage SQL Server under LinuxOur previous article described installing and configuring SQL Server under CentOS 7.3, and today we'll focus on how to use PowerShell under Windows to manage SQL Server under Linux. In fact, when it

13. T-SQL and SQL query AnalyzerWhat is SQL?What is T-SQL?Introduce new features of T-SQLHow to Use T-SQLSummaryIn this chapter, we will introduce some basic concepts about the Structured Query Language and transact-SQL and their differences. This

In keeping your servers and data secure from the current complex attacks, SQL Server has everything you need. But before you can effectively use these security features, you need to understand the threats you face and some basic security concepts.

by Don Kiely, 2014/06/18The seriesThis article is part of the stair series: a staircase to SQL Server security.SQL Server has everything you need to protect your servers and data from today's sophisticated attacks. But before you can effectively use